Faceoff: Surrogate vs. Natural Keys
نویسندگان
چکیده
The natural and surrogate key architectures are two competing approaches to specifying keys in relational databases. We analyze the performance of these approaches with respect to the update complexity and the query data and expression complexity. Our results provide new insights into the advantages and disadvantages of both approaches.
منابع مشابه
Performance Evaluation of Natural and Surrogate Key Database Architectures†
Keys allow a database management system to uniquely identify tuples in a database. Consequently, the class of keys is of a great significance for almost all data processing tasks. There are two competing approaches to specifying keys in relational databases. These are natural and surrogate key architectures. A natural key is an attribute subset of the relation schema that is known to users. A s...
متن کاملA Surrogate Concept for Engineering Databases
Relational database systems are attracting interest from users outside the commercial areas for which such systems were initially designed. This paper describes a surrogate model for engineering data (CAD, VLSI, geographical data, etc.) which allows the user to define structural relationships among semantically related data. A binding mechanism between system-controlled surrogates and user-defi...
متن کاملThe Generalized Pre-Grouping Transformation: Aggregate-Query Optimization in the Presence of Dependencies
One of the recently proposed techniques for the efficient evaluation of OLAP aggregate queries is the usage of clustering access methods. These methods store the fact table of a data warehouse clustered according to the dimension hierarchies using special attributes called hierarchical surrogate keys. In the presence of these access methods new processing and optimization techniques have been r...
متن کاملPower optimization of a piezoelectric-based energy harvesting cantilever beam using surrogate model
Energy harvesting is a conventional method to collect the dissipated energy of a system. In this paper, we investigate the optimal location of a piezoelectric element to harvest maximum power concerning different excitation frequencies of a vibrating cantilever beam. The cantilever beam oscillates by a concentrated sinusoidal tip force, and a piezoelectric patch is integrated on the beam to gen...
متن کاملTechnical Article
Fiber optic gyroscopes (FOGs), previously the low cost equivalent to other technologies such as ring laser gyroscopes (RLG), have some fresh competition. Microelectromechanical system (MEMS) gyroscopes are beginning to take market share away from traditional FOG applications. Specifically, antenna array stabilization, agricultural machine control, and general vehicle navigation are the battlegr...
متن کامل